Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_363

R_363

Person

LPersonPerson

PersonID

 

 

R_364

R_364

Kinship

LPersonPerson

KinshipID

 

 

R_428

R_428

Episode

LEpisodeAddress

EpisodeID

 

 

R_429

R_429

Address

LPersonAddress

AddressID

 

 

R_430

R_430

Person

LPersonAddress

PersonID

 

 

R_431

R_431

AddressType

Address

AddressTypeID

 

 

R_438

R_438

Language

KinshipText

LanguageID

 

 

R_474

R_474

Address

LEpisodeAddress

AddressID

 

 

R_487

R_487

PatientsGroup

LPatientGroup

PatientsGroupID

 

 

R_488

R_488

Patient

LPatientGroup

PersonID

 

 

R_501

R_501

Language

PatientsGroupText

LanguageID

 

 

R_502

R_502

PatientsGroup

PatientsGroupText

PatientsGroupID

 

 

R_515

R_515

Kinship

KinshipText

KinshipID

 

 

R_524

R_524

Language

PeriodStatusText

LanguageID

 

 

R_525

R_525

PeriodStatus

PeriodStatusText

PeriodStatusID

 

 

R_526

R_526

PeriodStatus

Period

PeriodStatusID

 

 

R_527

R_527

Period

CostServPeriod

PeriodID

 

 

R_544

R_544

Service

LServiceForm

ServID

 

 

R_557

R_557

Referral

Episode

ReferralID

 

 

R_561

R_561

Language

MaritalStatusText

LanguageID

 

 

R_568

R_568

EpisodeStatus

EpisodeStatusText

EpisodeStatID

 

 

R_569

R_569

Language

EpisodeStatusText

LanguageID

 

 

R_570

R_570

EpisodeStatus

Episode

EpisodeStatID

 

 

R_581

R_581

EpisodeType

EpisodeTypeText

EpisodeTypeID

 

 

R_582

R_582

EpisodeType

Episode

EpisodeTypeID

 

 

R_583

R_583

Language

EpisodeTypeText

LanguageID

 

 

R_585

R_585

Service

ServiceAddOns

ServID

 

 

R_590

R_590

Episode

Event

EpisodeID

 

 

R_594

R_594

MaritalStatus

MaritalStatusText

MaritalStatusID

 

 

R_602

R_602

EventType

EventTypeText

EventTypeID

 

 

R_604

R_604

EventType

Event

EventTypeID

 

 

R_605

R_605

Language

EventTypeText

LanguageID

 

 

R_621

R_621

Language

EducationText

LanguageID

 

 

R_622

R_622

Education

EducationText

EducationID

 

 

R_624

R_624

Language

OrgUnitKindText

LanguageID

 

 

R_625

R_625

OrgUnitKind

OrgUnitKindText

OrgUnitKindID

 

 

R_633

R_633

Event

LEventICD

EventID

 

 

R_634

R_634

ICD

LEventICD

ICDID

 

 

R_635

R_635

ICD

ICDText

ICDID

 

 

R_637

R_637

Language

ICDText

LanguageID

 

 

R_664

R_664

PerfService

LServPerfServ

PerfServiceID

 

 

R_669

R_669

PerfServiceStatus

PerfServStatusText

PerfServiceStatusID

 

 

R_674

R_674

ResourceItem

PerfResource

ResourceID

 

 

R_677

R_677

Service

LServServ

Ser_ServID

 

 

R_748

R_748

Step

SplitResultSum

StepID

 

 

R_786

R_786

Service

LServiceMaterial

ServID

 

 

R_789

R_789

MaritalStatus

Person

MaritalStatusID

 

 

R_790

R_790

Education

Person

EducationID

 

 

R_863

R_863

SysFct

LServiceForm

SysFctID

 

 

R_864

R_864

Patient

FormInstance

PersonID

 

 


1  2  3